﻿<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="DSRDWModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="Company">
          <Key>
            <PropertyRef Name="CompanyId" />
          </Key>
          <Property Name="CompanyId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="PeerGroupSectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IndicatorVersion" Type="int" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="200" Nullable="false" />
        </EntityType>
        <EntityType Name="CompanyIndicator">
          <Key>
            <PropertyRef Name="CompanyId" />
            <PropertyRef Name="IndicatorId" />
          </Key>
          <Property Name="CompanyId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="SectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IndicatorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IndicatorTopicId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IndicatorThemeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IndicatorScore" Type="int" Nullable="false" />
          <Property Name="IndicatorTemplateId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="IndicatorName" Type="nvarchar" MaxLength="250" Nullable="false" />
          <Property Name="IndicatorNumber" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="IndicatorTopicName" Type="nvarchar" MaxLength="250" />
          <Property Name="IndicatorTopicNumber" Type="int" />
          <Property Name="IndicatorThemeName" Type="nvarchar" MaxLength="250" Nullable="false" />
          <Property Name="IndicatorThemeNumber" Type="int" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view 'DSRDW.dbo.CompanyUniverse' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="CompanyUniverse">
          <Key>
            <PropertyRef Name="CompanyId" />
            <PropertyRef Name="StandardUniverseId" />
            <PropertyRef Name="GroupId" />
          </Key>
          <Property Name="CompanyId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="StandardUniverseId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="GroupId" Type="uniqueidentifier" Nullable="false" />
        </EntityType>
        <EntityType Name="Group">
          <Key>
            <PropertyRef Name="GroupId" />
          </Key>
          <Property Name="GroupId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="DefaultReferenceUniverseId" Type="uniqueidentifier" Nullable="false" />
        </EntityType>
        <EntityType Name="IndicatorWeight">
          <Key>
            <PropertyRef Name="IndicatorTemplateId" />
            <PropertyRef Name="MatrixId" />
            <PropertyRef Name="SectorId" />
          </Key>
          <Property Name="IndicatorTemplateId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="MatrixId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="SectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RelativeWeight" Type="int" Nullable="false" />
          <Property Name="IndicatorWeight" Type="float" Nullable="false" />
          <Property Name="ThemeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="TopicId" Type="uniqueidentifier" Nullable="false" />
        </EntityType>
        <EntityType Name="Sector">
          <Key>
            <PropertyRef Name="SectorId" />
          </Key>
          <Property Name="SectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="Type" Type="int" Nullable="false" />
          <Property Name="Number" Type="nvarchar" MaxLength="250" />
          <Property Name="Name" Type="nvarchar" MaxLength="250" Nullable="false" />
          <Property Name="CategoryId" Type="int" Nullable="false" />
          <Property Name="RootSectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="ShortName" Type="nvarchar" MaxLength="250" />
        </EntityType>
        <EntityType Name="ThemeWeight">
          <Key>
            <PropertyRef Name="MatrixId" />
            <PropertyRef Name="SectorId" />
            <PropertyRef Name="ThemeId" />
          </Key>
          <Property Name="MatrixId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="SectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="ThemeId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RelativeWeight" Type="int" Nullable="false" />
          <Property Name="ThemeWeight" Type="float" Nullable="false" />
        </EntityType>
        <EntityType Name="TopicWeight">
          <Key>
            <PropertyRef Name="MatrixId" />
            <PropertyRef Name="SectorId" />
            <PropertyRef Name="TopicId" />
          </Key>
          <Property Name="MatrixId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="SectorId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="TopicId" Type="uniqueidentifier" Nullable="false" />
          <Property Name="RelativeWeight" Type="int" Nullable="false" />
          <Property Name="TopicWeight" Type="float" Nullable="false" />
          <Property Name="ThemeId" Type="uniqueidentifier" Nullable="false" />
        </EntityType>
        <EntityContainer Name="DSRDWModelStoreContainer">
          <EntitySet Name="Company" EntityType="Self.Company" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CompanyIndicator" EntityType="Self.CompanyIndicator" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Group" EntityType="Self.Group" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="IndicatorWeight" EntityType="Self.IndicatorWeight" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Sector" EntityType="Self.Sector" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ThemeWeight" EntityType="Self.ThemeWeight" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="TopicWeight" EntityType="Self.TopicWeight" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CompanyUniverse" EntityType="Self.CompanyUniverse" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [CompanyUniverse].[CompanyId] AS [CompanyId], 
    [CompanyUniverse].[StandardUniverseId] AS [StandardUniverseId], 
    [CompanyUniverse].[GroupId] AS [GroupId]
    FROM [dbo].[CompanyUniverse] AS [CompanyUniverse]</DefiningQuery>
          </EntitySet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="DSRDWModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityType Name="Company">
          <Key>
            <PropertyRef Name="CompanyId" />
          </Key>
          <Property Name="CompanyId" Type="Guid" Nullable="false" />
          <Property Name="PeerGroupSectorId" Type="Guid" Nullable="false" />
          <Property Name="IndicatorVersion" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="CompanyIndicator">
          <Key>
            <PropertyRef Name="CompanyId" />
            <PropertyRef Name="IndicatorId" />
          </Key>
          <Property Name="CompanyId" Type="Guid" Nullable="false" />
          <Property Name="SectorId" Type="Guid" Nullable="false" />
          <Property Name="IndicatorId" Type="Guid" Nullable="false" />
          <Property Name="IndicatorTopicId" Type="Guid" Nullable="false" />
          <Property Name="IndicatorThemeId" Type="Guid" Nullable="false" />
          <Property Name="IndicatorScore" Type="Int32" Nullable="false" />
          <Property Name="IndicatorTemplateId" Type="Guid" Nullable="false" />
          <Property Name="IndicatorName" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IndicatorNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IndicatorTopicName" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="IndicatorTopicNumber" Type="Int32" />
          <Property Name="IndicatorThemeName" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IndicatorThemeNumber" Type="Int32" Nullable="false" />
        </EntityType>
        <EntityType Name="Group">
          <Key>
            <PropertyRef Name="GroupId" />
          </Key>
          <Property Name="GroupId" Type="Guid" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="255" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DefaultReferenceUniverseId" Type="Guid" Nullable="false" />
        </EntityType>
        <EntityType Name="IndicatorWeight">
          <Key>
            <PropertyRef Name="IndicatorTemplateId" />
            <PropertyRef Name="MatrixId" />
            <PropertyRef Name="SectorId" />
          </Key>
          <Property Name="IndicatorTemplateId" Type="Guid" Nullable="false" />
          <Property Name="MatrixId" Type="Guid" Nullable="false" />
          <Property Name="SectorId" Type="Guid" Nullable="false" />
          <Property Name="RelativeWeight" Type="Int32" Nullable="false" />
          <Property Name="IndicatorWeight1" Type="Double" Nullable="false" />
          <Property Name="ThemeId" Type="Guid" Nullable="false" />
          <Property Name="TopicId" Type="Guid" Nullable="false" />
        </EntityType>
        <EntityType Name="Sector">
          <Key>
            <PropertyRef Name="SectorId" />
          </Key>
          <Property Name="SectorId" Type="Guid" Nullable="false" />
          <Property Name="Type" Type="Int32" Nullable="false" />
          <Property Name="Number" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="Name" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="CategoryId" Type="Int32" Nullable="false" />
          <Property Name="RootSectorId" Type="Guid" Nullable="false" />
          <Property Name="ShortName" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="ThemeWeight">
          <Key>
            <PropertyRef Name="MatrixId" />
            <PropertyRef Name="SectorId" />
            <PropertyRef Name="ThemeId" />
          </Key>
          <Property Name="MatrixId" Type="Guid" Nullable="false" />
          <Property Name="SectorId" Type="Guid" Nullable="false" />
          <Property Name="ThemeId" Type="Guid" Nullable="false" />
          <Property Name="RelativeWeight" Type="Int32" Nullable="false" />
          <Property Name="ThemeWeight1" Type="Double" Nullable="false" />
        </EntityType>
        <EntityType Name="TopicWeight">
          <Key>
            <PropertyRef Name="MatrixId" />
            <PropertyRef Name="SectorId" />
            <PropertyRef Name="TopicId" />
          </Key>
          <Property Name="MatrixId" Type="Guid" Nullable="false" />
          <Property Name="SectorId" Type="Guid" Nullable="false" />
          <Property Name="TopicId" Type="Guid" Nullable="false" />
          <Property Name="RelativeWeight" Type="Int32" Nullable="false" />
          <Property Name="TopicWeight1" Type="Double" Nullable="false" />
          <Property Name="ThemeId" Type="Guid" Nullable="false" />
        </EntityType>
        <EntityType Name="CompanyUniverse">
          <Key>
            <PropertyRef Name="CompanyId" />
            <PropertyRef Name="StandardUniverseId" />
            <PropertyRef Name="GroupId" />
          </Key>
          <Property Name="CompanyId" Type="Guid" Nullable="false" />
          <Property Name="StandardUniverseId" Type="Guid" Nullable="false" />
          <Property Name="GroupId" Type="Guid" Nullable="false" />
        </EntityType>
        <EntityContainer Name="DSRDWEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Companies" EntityType="Self.Company" />
          <EntitySet Name="CompanyIndicators" EntityType="Self.CompanyIndicator" />
          <EntitySet Name="Groups" EntityType="Self.Group" />
          <EntitySet Name="IndicatorWeights" EntityType="Self.IndicatorWeight" />
          <EntitySet Name="Sectors" EntityType="Self.Sector" />
          <EntitySet Name="ThemeWeights" EntityType="Self.ThemeWeight" />
          <EntitySet Name="TopicWeights" EntityType="Self.TopicWeight" />
          <EntitySet Name="CompanyUniverses" EntityType="Self.CompanyUniverse" />
        </EntityContainer>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="DSRDWModelStoreContainer" CdmEntityContainer="DSRDWEntities">
          <EntitySetMapping Name="Companies">
            <EntityTypeMapping TypeName="DSRDWModel.Company">
              <MappingFragment StoreEntitySet="Company">
                <ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
                <ScalarProperty Name="PeerGroupSectorId" ColumnName="PeerGroupSectorId" />
                <ScalarProperty Name="IndicatorVersion" ColumnName="IndicatorVersion" />
                <ScalarProperty Name="Name" ColumnName="Name" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CompanyIndicators">
            <EntityTypeMapping TypeName="DSRDWModel.CompanyIndicator">
              <MappingFragment StoreEntitySet="CompanyIndicator">
                <ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
                <ScalarProperty Name="SectorId" ColumnName="SectorId" />
                <ScalarProperty Name="IndicatorId" ColumnName="IndicatorId" />
                <ScalarProperty Name="IndicatorTopicId" ColumnName="IndicatorTopicId" />
                <ScalarProperty Name="IndicatorThemeId" ColumnName="IndicatorThemeId" />
                <ScalarProperty Name="IndicatorScore" ColumnName="IndicatorScore" />
                <ScalarProperty Name="IndicatorTemplateId" ColumnName="IndicatorTemplateId" />
                <ScalarProperty Name="IndicatorName" ColumnName="IndicatorName" />
                <ScalarProperty Name="IndicatorNumber" ColumnName="IndicatorNumber" />
                <ScalarProperty Name="IndicatorTopicName" ColumnName="IndicatorTopicName" />
                <ScalarProperty Name="IndicatorTopicNumber" ColumnName="IndicatorTopicNumber" />
                <ScalarProperty Name="IndicatorThemeName" ColumnName="IndicatorThemeName" />
                <ScalarProperty Name="IndicatorThemeNumber" ColumnName="IndicatorThemeNumber" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Groups">
            <EntityTypeMapping TypeName="DSRDWModel.Group">
              <MappingFragment StoreEntitySet="Group">
                <ScalarProperty Name="GroupId" ColumnName="GroupId" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="DefaultReferenceUniverseId" ColumnName="DefaultReferenceUniverseId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="IndicatorWeights">
            <EntityTypeMapping TypeName="DSRDWModel.IndicatorWeight">
              <MappingFragment StoreEntitySet="IndicatorWeight">
                <ScalarProperty Name="IndicatorTemplateId" ColumnName="IndicatorTemplateId" />
                <ScalarProperty Name="MatrixId" ColumnName="MatrixId" />
                <ScalarProperty Name="SectorId" ColumnName="SectorId" />
                <ScalarProperty Name="RelativeWeight" ColumnName="RelativeWeight" />
                <ScalarProperty Name="IndicatorWeight1" ColumnName="IndicatorWeight" />
                <ScalarProperty Name="ThemeId" ColumnName="ThemeId" />
                <ScalarProperty Name="TopicId" ColumnName="TopicId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Sectors">
            <EntityTypeMapping TypeName="DSRDWModel.Sector">
              <MappingFragment StoreEntitySet="Sector">
                <ScalarProperty Name="SectorId" ColumnName="SectorId" />
                <ScalarProperty Name="Type" ColumnName="Type" />
                <ScalarProperty Name="Number" ColumnName="Number" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="CategoryId" ColumnName="CategoryId" />
                <ScalarProperty Name="RootSectorId" ColumnName="RootSectorId" />
                <ScalarProperty Name="ShortName" ColumnName="ShortName" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ThemeWeights">
            <EntityTypeMapping TypeName="DSRDWModel.ThemeWeight">
              <MappingFragment StoreEntitySet="ThemeWeight">
                <ScalarProperty Name="MatrixId" ColumnName="MatrixId" />
                <ScalarProperty Name="SectorId" ColumnName="SectorId" />
                <ScalarProperty Name="ThemeId" ColumnName="ThemeId" />
                <ScalarProperty Name="RelativeWeight" ColumnName="RelativeWeight" />
                <ScalarProperty Name="ThemeWeight1" ColumnName="ThemeWeight" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="TopicWeights">
            <EntityTypeMapping TypeName="DSRDWModel.TopicWeight">
              <MappingFragment StoreEntitySet="TopicWeight">
                <ScalarProperty Name="MatrixId" ColumnName="MatrixId" />
                <ScalarProperty Name="SectorId" ColumnName="SectorId" />
                <ScalarProperty Name="TopicId" ColumnName="TopicId" />
                <ScalarProperty Name="RelativeWeight" ColumnName="RelativeWeight" />
                <ScalarProperty Name="TopicWeight1" ColumnName="TopicWeight" />
                <ScalarProperty Name="ThemeId" ColumnName="ThemeId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CompanyUniverses">
            <EntityTypeMapping TypeName="DSRDWModel.CompanyUniverse">
              <MappingFragment StoreEntitySet="CompanyUniverse">
                <ScalarProperty Name="CompanyId" ColumnName="CompanyId" />
                <ScalarProperty Name="StandardUniverseId" ColumnName="StandardUniverseId" />
                <ScalarProperty Name="GroupId" ColumnName="GroupId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>